USE [StormwindSecurity]
GO

DECLARE	@return_value int,
		@ApplicationId uniqueidentifier

SELECT	@ApplicationId = newid()

EXEC	@return_value = [dbo].[aspnet_Applications_CreateApplication]
		@ApplicationName = N'Stormwind Reports',
		@ApplicationId = @ApplicationId OUTPUT

SELECT	@ApplicationId as N'@ApplicationId'

SELECT	'Return Value' = @return_value

GO

USE [StormwindSecurity]
GO

DECLARE	@return_value int,
		@UserId uniqueidentifier

EXEC	@return_value = [dbo].[aspnet_Membership_CreateUser]
		@ApplicationName = N'Stormwind Reports',
		@UserName = N'StormwindSecurity',
		@Password = N'StormwindSecurity123#',
		@PasswordSalt = N'12345',
		@Email = N'sm@sm.com',
		@PasswordQuestion = N'who',
		@PasswordAnswer = N'am i',
		@IsApproved = 1,
		@CreateDate = '20070614 00:00:00',
		@CurrentTimeUtc = '20070614 00:00:00',
		@UserId = @UserId OUTPUT

SELECT	@UserId as N'@UserId'

SELECT	'Return Value' = @return_value

GO
